PGDM Core Subject
Data Visualization with Power BI
Course Objective
Primary Mapping: PO4 (Communication) & PO8 (Lifelong Learning). Textbook: Microsoft Power BI Data Analysis and Visualization by S. Pearson.
Evaluation Scheme
- 6 Assignments: 30 Marks (5 Marks each).
- Class Participation: 20 Marks.
- Mid Term: 20 Marks.
- End Term: 30 Marks.
|
Session |
Session Name |
Pre-Reading (Approx. Pages) |
Assignment (5M) |
|
1 |
Dashboard Architecture |
Ch 1: Visual Storytelling (pp. 5-25) |
|
|
2 |
Connecting Data Sources |
Ch 2: Getting Data (pp. 30-50) |
A1: Source Linking |
|
3 |
Power Query Mastery - I |
Ch 3: Transforming Data (pp. 55-75) |
|
|
4 |
Power Query Mastery - II |
Ch 3: Merging/Appending (pp. 76-95) |
A2: Data Cleaning |
|
5 |
The Star Schema Model |
Ch 4: Data Modeling (pp. 100-120) |
|
|
6 |
DAX Foundations |
Ch 5: DAX Basics (pp. 130-150) |
A3: Simple Measures |
|
7 |
Time Intelligence in DAX |
Ch 5: YTD/YoY Logic (pp. 151-175) |
|
|
8 |
Filter Context vs. Row Context |
Ch 6: Advanced DAX (pp. 180-200) |
A4: Complex DAX |
|
9 |
Visualizing Trends (Line/Bar) |
Ch 7: Basic Visuals (pp. 210-230) |
|
|
10 |
Mid Term Dashboard Exam |
Review Sessions 1-9 |
Mid Term (20M) |
|
11 |
Advanced Maps & Geospatial |
Ch 8: Map Visuals (pp. 240-260) |
|
|
12 |
Drill-throughs & Tooltips |
Ch 9: Interactivity (pp. 270-290) |
A5: Interactive UI |
|
13 |
Bookmarks & Buttons |
Ch 9: Storyline Navigation (pp. 291-310) |
|
|
14 |
KPI Dashboards for Execs |
Ch 10: Executive Reports (pp. 320-340) |
A6: KPI Design |
|
15 |
AI Visuals (Q&A/Key Influencers) |
Ch 11: AI Integration (pp. 350-370) |
|
|
16 |
Row Level Security (RLS) |
Technical Note: Data Privacy |
|
|
17 |
Publishing to Power BI Service |
Ch 12: Collaboration (pp. 380-400) |
|
|
18 |
Automated Refreshes & Gateways |
Technical Note: Scheduled Jobs |
|
|
19 |
Mobile Dashboard Optimization |
Manual: Mobile Layout Design |
|
|
20 |
Final Project Presentation |
Portfolio Review |
End Term (30M) |